You are here: Main Menu > I. Interface Menu > 7. External System > F. ESI Trial Balance

ESI Trial Balance

The ESI Trial balance function is used to export the trial balance for a specific accounting period and year

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Period field, enter the accounting period for the ESI Trial Balance file.

3. At the Year field, enter the year for the ESI Trial Balance file.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the Period field.
Select yes to create a new file with the same name that already exists.

4. The following message will display: "Print Report? No/Yes."

Select no if you do not want to print the report.
Select yes to print the report.

5. The following message will display: "Create a delimited ASC file? No/Yes?"

Select no to create a DBF file only.
Select yes to create a DBF file and an ASC file.

Two DBF files will be created TBPPYYYY.dbf and TB_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The TBPPYYYY.dbf file is the ESI Trial balance file for the selected period and year with PPYYYY equal to the period and year selected. The TB_Last.dbf is a copy of the current file. If an ASC file was created the name will be TBPPYYYY.asc and will be found in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

If you selected yes in Step #4 to print a report, command options will appear allowing you to print or choose from a set of other print options. The following information will print:

Acct – The account number
Cost Center – The cost center
Account Description – The name of the account
Beginning Balance – The beginning balance for the account
Debit – The total debits for the account, in dollars, for the accounting period selected
Credit – The total credits for the account, in dollars, for the accounting period selected
Ending Balance – The ending balance for the account.

The following fields will be exported from the system:

Field Name	Description	Type
PERIOD	The accounting period	C 2
YEAR	The accounting year	C 4
ACCOUNT	The general ledger account number	C 4
SUB_ACCT	The cost center ID	C 6
ACCT_DESC	The account description	C 30
BEG_BAL	The beginning account balance	N 13, 2
DEBIT	The amount debited for the account in the accounting period selected	N 13, 2
CREDIT	The amount credited to account in the accounting period selected	N 13, 2
END_BAL	The ending account balance	N 13, 2

Security Required : Ledger - Ledger Reports